package cn.com.cabinet.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.cabinet.web.entity.Seller;

public interface SellerDao extends JpaRepository<Seller, Long>,JpaSpecificationExecutor<Seller>{
	
	
	@Query(nativeQuery=true,value="select * from ict_seller s where s.sMark = ?1 limit ?2,?3")
	public List<Seller> getSellerApplication(int sMark,int page,int limit);
	
	@Query("select s from Seller s where s.sMark = ?1")
	public List<Seller> getSellerApplicationCount(int sMark);
	

}
